﻿/*CREATE TABLE [dbo].[Bills] (
    [Id]                 INT            IDENTITY (1, 1) NOT NULL,
    [Title]              NVARCHAR (MAX) NOT NULL,
    [Date]               DATETIME       NOT NULL,
    [Summary]            NVARCHAR (MAX) NOT NULL,
    [Content]            NVARCHAR (MAX) NOT NULL,
    [Digest]             NVARCHAR (MAX) NOT NULL,
    [ChamberId]          INT            NOT NULL,
    [Number]             NVARCHAR (MAX) NOT NULL,
    [Status]             NVARCHAR (MAX) NOT NULL,
    [LongTitle]          NVARCHAR (MAX) NOT NULL,
    [TariffPropType]     NVARCHAR (MAX) NULL,
    [BillHomePILink]     NVARCHAR (MAX) NOT NULL,
    [LatestStage]        NVARCHAR (MAX) NULL,
    [BillTextPILink]     NVARCHAR (MAX) NOT NULL,
    [Parliament_Id]      INT            NOT NULL,
    [Parliamentarian_Id] INT            NULL,
    [Portfolio_Id]       INT            NULL
);*/















